How to match Queueitem key and DatatableCoumn

[Raja.G (Mr.RPABot)]

HI Team,

I have queue json and datatable, I want to match queuejson key and datatable column.

If match i need to fetch column value matched columnname and queuejsonkey and value to store bulid data table.

Please help me anyone for this.

Queue json

Excel data

Expected result:

Regards,
Raja G

[ashokkarale]

@Raja.G,

Here is a way you can achieve this.

Queue Item:

Input:

Outptu:

Sample Code:
SampleCode.zip (17.5 KB)

Thanks,
Ashok

[Raja.G (Mr.RPABot)]

Hi @ashokkarale ,

Thanks, I have one question if column name not matched queuejson it throw exception right?

If we add catch block systemexption.contain(“error”) ,it will go out loop not worked please help me on this.

I am not using excel , i just store data to datatable .

Regards,
Raja G

Regards,
Raja G

[ashokkarale]

@Raja.G

@Raja.G

if column name not matched queuejson it throw exception right?

No, it will not throw exception. It will continue checking further. You can add if condition to check if any columns were matched or not.

Revised solution would be like this.

Thanks,
Ashok

[Raja.G (Mr.RPABot)]

@ashokkarale ,

Thanks its working as expected .

Regards,
Raja G