Hi Team,
I need help. I have a dataset which has no column names . Please find attached the input and the desired output.
Please let me know your thoughts,
Thanks,
Sr
Solved! Go to Solution.
Hi @atcodedog05 ,
I think I have fair idea what I need. The values in the map file should look for similar values in all the columns of the data file. If it finds more than 1 then it should be counted as 1 for that particular row.
thanks
Hi @sriniprad08
Can you provide some sample input and expected output It will help us get a better understanding of the usecase.
We will be happy to help : )
Hi @atcodedog05 ,
Thank you for offering to help. Please find attached the file with input and expected output inside it.
1) Create a new column (Site_new) - The value in the map file has to search through the input data file by each ROW and create a new column. if the value appears more than once in a row then it should be treated once.
2) Take count of the new column - In the second step it has to take the count of the new column (Site_new) by Site code and Site.
Thanks for the help 🙂
Cheers,
Sri
Hi @atcodedog05 ,
Thank you for the help 🙂 .Couple of clarifications from my end,
1) The header in this below marked in black is also a record and not the actual header. We need to create a header for all the columns.how can we go about that please?
2. This part below seems to be hardcoded. Is there way it can combine all the text. Not sure . please let me know your thoughts,
In real data do we need to combine all the headers?
Thank you for the help again. Please let me know if i am missing anything.
Cheers,
Sr
Hi @atcodedog05 ,
Sorry for the delayed reply. Thank you so much for the help :). I will let you know incase of any further help.
Have a nice day,
Cheers,
Sri
Happy to help : ) @sriniprad08
Cheers and have a nice day!
Hi @atcodedog05 ,
Hope you are well. I need help. In the flow you provided , i would like to create a column based on the "Site_new". if there are multiple values in the row then a new column should be created "indicator".
Formula will be - if count of (Site_new) is > 1 then 1 or 0.
In the below case we can see marked in "Red" has two values . So the output should be 1 in the "new column" created.
Please let me know how to go about this,
Thanks
Sri