select_over_two_tables.yxmd
Hi!
I have two input-files.
The first file (alphabet) include columns A,B,C,D;E....
The second file (alphanumeric) include in a column ABC the column names of the first file as content.
I made a pivot with cross Tab Tool so I get one column with each row entry of ABC.
For example:
First CSV: (alphabet)
A;B;C;D;E
1;2;3;4;5
1;2;3;4;5
1;2;3;4;5
...
Second CSV-File:(alphanumeric)
Run-ID;ABC
100;A
200;A
300;B
400;C
400;B
400;A
...
With the Filter Tool and the Cross Tab Tool a made a functionalty like the sql syntax (for example)
select ABC from alphanumeric where RUN-ID = 400
result:
RUN-ID;new_field
400;C,B,A
Now I will the two results together.
It is possible in Alterxy to build a functionalty like the sql syntax?
select C,B,A from alphabet
result:
3;4;5
Mathias
