Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table with 1 ID-column and 10 columns called C_1, C_1_expl, C_2,... . I would like to load each of them in a generic load, i.e. the column names are in the C_i_expl-columns. If I naively do generic loads for each i, I get 5 additional tables which are connected to eachother via the ID-column.
So instead, I loaded the ID-column 5 times (under ID_1, ID_2,...), one for each generic load. But now I have the problem that sometimes, C_2_expl contains the same entry as C_1_expl, but they result in different tables. Is there an easy way out?
It sounds like you want to do a crosstable load, rather than a Generic load.
-Rob