Get specific Excel column values (two column values with same column name but with different column positions) based on one source column(Let's say source column is A))

[eshwarsai_ks]

Hi friends, @aanandsanraj ,I have another excel file where I need to get client-wise DIFF values. The problem is there are two DIFF columns and I want to get two DIFF values for the respective clients.

But the challenging part is DIFF columns position will change for some clients. PLease find the attached file below. the attached excel file has different structure.

Test_Dec02.xlsx (53.3 KB)

Please find the attached excel file for your reference suggest me how to get those two DIFF values for the respective clients like the one you have done for the yesterday file.Test_Dec02.xlsx (53.3 KB)

[aanandsanraj (Anandraj Rajendran)]

Hi @eshwarsai_ks,

I hope the attached xaml will help you try it
Process.xaml (17.5 KB)

[eshwarsai_ks]

I will check and get back to you @aanandsanraj Thank you so much for your time

[eshwarsai_ks]

Hi @aanandsanraj , Thanks a lot I have tested the code, I’m happy to see that the output file had the required data(expected output). but getting the below error

[aanandsanraj (Anandraj Rajendran)]

@eshwarsai_ks

Check on this xaml Process.xaml (19.6 KB)

[eshwarsai_ks]

After the Output file is created , the data inside the excel is accurate but I don’t know why the below error is popping up bro. RObot has to stop the code…instead it is giving the below error

[jeevith (Jeevith Hegde, Ph.D.)]

It looks like the dtOutput datatable is empty. That error is just basically saying “I cannot count when there is nothing to count”

A better check would be as suggested here : How to know if DataTable is null or Empty

Just ensure your logic is handled in the correct sequence (true, false) when you use the solution in the above link.

[eshwarsai_ks]

Thanks @jeevith, It worked

[eshwarsai_ks]

It worked well @aanandsanraj. Thank you so much

[eshwarsai_ks]

Hi @aanandsanraj , just noticed that for one client(ERA SAMSUNG BUNDLING) , there are no DIFF values filled by the robot.
output file.xlsx :

SOurce file :

the above DIFF values are not available in the Output.xlsx file

Please suggest me if any @aanandsanraj

Thank you

[aanandsanraj (Anandraj Rajendran)]

@eshwarsai_ks
Is this the same file you shared earlier?

[eshwarsai_ks]

Yes @aanandsanraj. same file

[aanandsanraj (Anandraj Rajendran)]

@eshwarsai_ks

Because ERA SAMSUNG BUNDLING “DIFF” column is mentioned in next row it is not like rest of the clients. All other client has it in the same row.

[eshwarsai_ks]

Very true @aanandsanraj. Thanks a lot for your quick update