split the dataset based on the columns name

debanasser1
Level 2
split the dataset based on the columns name

I want to split the dataset into two datasets based on the column name ,

so col A,col B go to dataset 1

and col C go to dataset 2

is it possible ?

 

 

0 Kudos
3 Replies
imanousar
Level 3

I think you will have to create 2 SQL recipes for that:

 

Select A,B from ....

Select C from ....

or a single python recipe 

 

The split method provides only row based splitting so I don't think you can do it with visual recipes. 

0 Kudos
debanasser1
Level 2
Author

Thanks ,

I tried stack and it worked ๐Ÿ‘๐Ÿป

0 Kudos
imanousar
Level 3

With just a single stack recipe? 

0 Kudos