Hi,
I have 2 excel sheets, In sheet 1 we applied some filter tabs and in Sheet 2 we have some text and some items. we want to get the text from sheet 2 which is against the item after applying the filter tabs.
Regards,
Generally you can use ,Read range or read cell to get the data from the excel.
Can you show some screenshot regarding what you need to get in the excel ?
Regards
Sudharsan
It would be a better approach if you use them as a DataTable and then apply filters on DataTable, and then apply Lookup to find the value.
It would be easy to do it, rather than doing all the work in excel itself.
Thanks!
can you explain more on this?? or else can we connect for a quick call on google meet??
Regards,
Hi,
Use Read Range activity to read excel into a datatable, use Filter datatable activity to filter records then use lookup datatable activity to look for the value you want to find.
Thanks
Thanks Prateek.
But should I need to use 2 read range activities to read 2 sheets??
Regards,
Yes, Read both the sheets into a different datatable.
Alternate: You could also use Vlookup formula in excel to do your task and then use Autofill activity to drag formula to all rows.
thanks.
I have taken 2 read ranges, in filter data table what we need to take??
Regards,
What ever filters you want to apply on your table.
I want IQ Ticket values against these Dtaps. Actually these Dtaps are also in other sheet. We want to get the exact tickt number for the particular Dtaps
can you say the condition for this??
Regards,
We applied filter tabs in this sheet and we get these DTAPs.
Now we need the IQ ticket number for the particular DTAP from other sheet.
Regards,
Ok, so pick this value dtap and do a lookup datatable in the other datatable that you read and get the output
what filters should I use in Filter data table??
Regards,
Hey,
They 5 DTAP’s you shared above from the entire list of DTAP’s, will these always be static ?
i.e. always filter on these 5 only ?
Hi @raju_alakuntla ,
Can you please help me to understand your concern. I am guessing that you have 2 data sheets one contains Dtap with ticket number and other sheet containing Dtap and other stuff.
Here you want the ticket number which is not matching the Dtap in two tables.?
Am I right.?
They may be dynamic, depends on the requirement it changes the Number of DTAPS, but we need ticket number for that particular Dtap.
regards,
no. We should match the DTAPs in both the sheets and need to get the Ticket number for the particular DTAP.
regards,
if your DTAPs are unique, why don’t you join both the dataTables and get the required value?