I have simple case, but do not know how to solve it.
- I create DataTable with 4 columns “date”, “name”, “age”, “city” - dtEmployee. From the beginning rows are empty. (ok - it is easy)
- I have some excel file where are 3 columns…it can be ( “date”, “name”, “age”) or (“name”, “age”, “city”) or (“age”, “city”,“date”) - I know that inside of excel file will be 3 column with the same name but not with same place as in dtEmployee (TypeArgument: “system.datetime”, “string”,“int 32”,:string")
I read this file: Excel application scope ->Read Range->Output data table and I have DataTable with Input tblReport (TypeArgument: “string”). (ok - it is easy too)
- I do not know what kind of activity I should use or how to write queue or…How I can transfer data from tblReport to dtEmployee…I understand that I need to check which columns has matches and I need to put “NULL” or it should be empty for columns which data does not exists in dtEmployee