Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.
Answers:
1
Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...
Answers:
1
Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...
Answers:
3
Apologies if my query has been answered elsewhere, but I haven't been able to find a relevant article / direction so far. I have an API source that is drawn into VDP as a JSON format. The API accepts dates as input parameters. Based on the dates enter...
Answers:
2
Hello, I have a table with an ID of a company and WS for getting an information if the company can be trusted or not. The problem is with the WS. In default, it has parametrized input array of string and returns two arrays of outputs. I used FLATTEN fu...
Answers:
3
I am creating a flatten view on top of the base view of JSON Data Source. I want a new field to be added in the output within which the field contains file name( ex:- name.json) as value.
Answers:
1
I have a JSON datasource which returns a hierarchy along the lines of the JSON below. The key thing here is that from one web service call to the next the folder structure can differ i.e. each folder is an array and can contain different numbers of sub...
Answers:
1
I'm trying to flatten some json data coming in and no matter where I click in a results array through the flatten wizard the "flatten field...xyz" option is greyed out. What am I missing?
Answers:
1
I have a view where certain array that I need to flatten may be null or may not contain the specific row that I am looking for. When flattening such array, I get an empty result. How do I manage such array during flattening? Eg. Say I have this data I...
Answers:
7
Hello, I have Created a Base view from a BAPI Data source In that Base View I am having three arrays as its columns array [1] is having a primary key array [2] is having details array[3] is having some more info Now these three are columns of Ba...
Answers:
8