Hello Everyone,
Can any one help me solve the below problem. Currently my data looks below
I want the data in one line. For example to bring the 1 & 2 record in one line, based on the second column, help me out.
Hi @oiciadteam
If you could provide an example of your expected output, I am sure a solution could be found. It seems that many of the fields for each POL_POLICY_NO are identical, but for those that are not, it needs to be established how to either aggregate the data (i.e. should Category 1 always take precedence or some other logic applied), or if each field should be duplicated so you get a Member_Category_1 and Member_Category_2?
@oiciadteam,
Please see below
you can use the unique tool and do a unique on the column 2.
Attached the workflow.
Hope that helps,
Regards,
You can use a sample tool to grab one record, per unique value.
This will grab the first instance it sees. I've selected the second column as a group by, so it'll grab the first value per value.
Hi All,
I have attached excel file. In the excel files there are sheet 1 ) Refined - this shows what I am expecting 2) Original - This shows the original data.
Please assist how this can be done.
Hi per
I have attached the sample file and what result i am excepting
