Vlookup studio x running too long

Help StudioX
,
1

hi, im having a trouble for vlookup, im using studio x community.
the thing is it is running too long.

is anyone know why is it too long running for vlookup part?

image
image702×653 22.9 KB

2
  1. If you have a large dataset, the VLOOKUP operation can take longer to process, especially if you are searching through multiple columns or rows.
  2. Complex Formula: If your VLOOKUP formula is complex with many nested functions or conditions, it can slow down the execution.
  3. Remote Data Source: If you are performing the VLOOKUP on a remote data source or network location, the latency or network issues can lead to delays.
  4. Insufficient Resources: Your computer’s hardware might not be sufficient to handle the processing of large datasets or complex formulas efficiently.

Hope it helps,

3

Hi @Nur_Amin

image
image1242×665 22.2 KB

Check on this thread

I hope it helps!!

4

hi, it come out fail after running too long.

for each excel row fail. why ya?

5

Hi @Nur_Amin

  • Check the size of the Excel file that you are using. If the file is very large, you may need to break it up into smaller files.
  • Simplify the VLOOKUP formula. If the formula is complex, it may be taking a long time to process.
  • Update the VLOOKUP activity. updating it to the latest version may fix the issue.

Hope it helps!!

6

@Nur_Amin

Try reading the data into datatable and then use lookup datatable activity…that might be more faster

Cheers

7

i have done like this thread but it appear like this why ya?

image
image1417×245 21.4 KB

8

image
image1007×470 33.2 KB

hi anyone has idea on this please help