Pull data from two csv file

Support
1

I have 500000 entries. divided into two files like first file name is 'a' and has 250000 entries. then the second file name is 'b' have 250000 entries. I want to check the data on both files.
i want to pull data from both csv
its not working
here is my code

WhatsApp Image 2023-06-06 at 1.41.05 PM
WhatsApp Image 2023-06-06 at 1.41.05 PM1156×155 45.5 KB

a.csv (32 Bytes)
b.csv (33 Bytes)

2

Hi @azam_iqbal,

I would try 2 calculate :

  • one pulldata from file A
  • the other from file B

AND then a calculate to get the first non null value : COALESCE(${calculate_A},${calculate_B})

3

Can you share this in excel form (example)

4

See also your discussion in Kobo community https://community.kobotoolbox.org/t/pull-data-from-two-csv-file/41808