Select count not working base in variable
Hi,
I want to pass the filename from parameter(pipeline-parameter) and check if that file is already loaded or not. If not loaded, then we go ahead to load it otherwise we do nothing.
Actually i ...
Forum Discussion
Thanks so much! This is very helpful.
Here is a new slp which includes two new solutions to your problem, more optimized than the one given above earlier.
The solution using the pivot snap sorts by the column names, which might not result in the same order as coming in. It works now because the columns are C, D, E. But, if the last three columns in the real thing are not alphabetical, it might not work like you want.
The solution using the mapper snaps does not have the problem listed above. So, depending on your desired behavior you can choose and play with the solutions to fit your use case.
Also note, these solutions are using the actual column names themselves that are to be collected and written out, so if those plan to change this will need to be edited accordingly to handle that.
PivotQuestion_2019_08_29.slp (14.6 KB)
tchaitenyakumar - I saw this post a while back but didn't have time to respond. Can you simplify your question to specific translation issues (i.e. maybe 5-6 fields)?
Thanks Koryknick. I am able to resolve that. I have a question how can i pass value(C7999898) as URI Parameters in snap pipeline
