Error in Snowflake - Select Snap
Hello,
I have a parent and child pipeline where the parent pipeline sends some venue details to child pipeline. Based on the venue details, the child pipeline calls a REST GET to acquire data from ...
Forum Discussion
Ok well… Here’s another issue.
That export works great as long as the field names are unique in the output of the JSON.
But if they are the same it fails and there is no way I can think of to remedy that issue.
so this is really weird but in the API we are calling from it returns subtables inside the output of the parent table example.
select ,child. from parent
- gives all the fields of the parent and child.* gives all from the child.
There is no way that I can think of with that splitter method to name the columns uniquely since I really do need to give them unique names.
I wouldn’t mind if I was able to get the columns ordinally or have it append some kind of index to the field. say id,id_1,id_2.
Put I haven’t been able to figure that out.
Please find the attached sample pipeline containing the expression that you can use to append an index to the object keys.
SL_Community_1_2021_02_28.slp (4.7 KB)
Hope that will helps!
Regards!
Thank you @bojanvelevski , perfect it is working as expected.
Thank you @kkishore, can you please mark @bojanvelevski’s suggestion as a Solution so that anybody looking at this thread in the future can refer to the solution directly?
