Pull data from two csv file

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

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

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})

Can you share this in excel form (example)

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