Hello,
I have read some data from an excel file. i have to filter data that matches data available in another table in a loop. I have used reference row filter for this. The data is in format
{variable data line1}
constant1
constant2
space
{variable data line2}
constant1
constant2
space
i have formed a loop to form the reference data like
{variable data line}
constant1
constant2
and try to match it with the input data but it matches something like this:
{variable data line1}
constant1
constant2
constant1
constant2
constant1
constant2
I want it to match like below, in each iteration
{variable data line}
constant1
constant2
How to achieve this
Hi,
Would you provide a sample data and explain your question a bit more? Then I think I can help you.
Best,
Armin
Hello Armin,
I have attached an Excel.
The input is similar to the data in Sheet 1 and I want the results as in Sheet 2Survey.xlsx (9.8 KB)
But reference row filter is not working for me as I expected.
Thanks in advance,
Best Regards,
Vinayashree M S
OK,
Here is what I have done:
I filtered the questions and the answer set. Then convert the answer set to columns and put the number of answers into its corresponding cell and finally joined the questions and the answers.
Check the workflow and let me know if it’s what you are looking for.
The input table:
The final output:
The workflow:
survey.knwf (84.4 KB)
Best,
Armin
1 Like
