Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

schem mapping tables source to target

Highlighted
5 - Atom

Hi, 

I would like to know if it possible with ALTERYX Designer to perform schema mapping from source to target with table/column mapping that would  show the difference and matches where possible between two files 

 

on Alteryx designer 11.7 

 

EXAMPLE : SOURCE  INPUT FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJSMYIDANUMBER
RTVSJSVERSIONNUM1NUMBER1

 

EXAMPLE : TARGET   INPUT FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJBMYIDNUMBER
RTVSJBVERSIONNUM1NUMBER

 

EXAMPLE : OUPTUT RESULT  FILE  EXCEL 

TABLE_NAMECOLUMN_NAMEDATA_TYPE
RTVSJS - NO MATCHMYIDNUMBER
RTVSJS - MATCH VERSIONNUM1NUMBER

 

Highlighted
14 - Magnetar
14 - Magnetar

Hi @sbellinialt ,

 

What about a Join tool, joining on all of the fields? Anything that doesn't map will come out of the left or right input. You could use a formula tool to add the "no match"  or "match" either to an existing field or new field, and then union everything back together.

 

Cheers!

Esther

 

5 - Atom

Would it be possible to do this with Alteryx Workflow by using tool sql ?

Labels