Validation Tranform - Concatenation of two columns in a condition

[Former Member]

Hi All,

I have two tables TableA and TableB.

TableA Data:

C4	C5
A100	ABC
B200	BBB
C300	ABC
D400	BBB
E500	ABC
F600	BBB
G700	ABC
H800	BBB

TableB Data:

C1	C2	C3
A	100	xxxx
B	200	xxxx
C	300	xxxx
D	400	xxxx
G	700	xxxx
H	800	xxxx

I want to load the data to TableC with columns C6 and C7.

My Data flow is like this:

TableA --> Validation Transform --> Pass--> TableC

I want give the condition  TableA.C4=TableB.C1||C2. How to do that?

Please advise.

TableC Data:

C4	C5	C3
A100	ABC	xxxx
B200	BBB	xxxx
C300	ABC	xxxx
D400	BBB	xxxx
G700	ABC	xxxx
H800	BBB	xxxx

[Former Member · Accepted solution]

Hi Aretha,

Create one dummy column in Table B with concatenation of B.Dummy = B.C1 + B.C2 and then use this dummy one in the validation transform , Again in Validation transform use custom condition to compare column values to validate.

Thanks..

[Former Member · Accepted solution]

HHi Srinivas,

I don't want to create new column in TableB.

IS there any other way to do?

Thanks

[Former Member · Accepted solution]

Hi Aretha,

Just create a dummy column and delete before target. or you can use Query transform to do this

[Former Member · Accepted solution]

Hi Arthera,

In that case use Concatenation directly in custom function in validation transform

Thanks,

[Former Member · Accepted solution]

How to do this in custom validation? I am unable to do this.

Please help me.

[Former Member]

Dirk Venken

Please help me.

[Former Member]

Choose custom condition and add the formula in condition editor

[Former Member]

Hi Srinivas, Thanks for the screens.

But your screens shows same query data set.

I want map like this for two different data sets or tables:

TableA.C4=TableB.C1 || TableB.C2

[Former Member]

I am lazy to keep full query, try keeping what ever you want

[former_member187605]

Don't use a Validation transform here, it makes no sense.

The only thing you need is a Query transform, simply joining both tables with the condition TableA.C4=TableB.C1 || TableB.C2, as explained by Pravi Nellikkal above (forget about the extra dummy column, too, you  don't need it either).