How to split the non-key column to separate table with key column in both

Split the non-key columns to separate tables with key columns in both / How to split the data of source table column-wise with respect to the primary key. See the source and target tables below.

example:

source table
id name phone
10 aa 123
20 bb 234

tgt1:
id name
10 aa
20 bb
tgt2:
id  phone
10 123
20 234

Beginner Asked on March 9, 2021 in Diyotta Studio.
Add Comment
1 Answer(s)

Get the source table data to the Temp stage area. From the temp stage,  then add two expressions one is for id, name attributes another expression id, phone no attributes.

complete dataflow for refrence

RE: How to split the non-key column to separate table with key column in both

Target 1 : output

RE: How to split the non-key column to separate table with key column in both

Target 2:  output

RE: How to split the non-key column to separate table with key column in both

Expert Answered on March 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.