Copy the value into all the rows

vikasshana — Fri, 09 Sep 2022 06:22:45 GMT

Hi,

I've the below data in my app.

And using the below load script to create two new columns like below

Load ID,
Number,
if(Len(Number)=6, Number) as Number1
if(Len(Number)>6, Number) as Number2

I received below output.

But I'm looking for below output

Re: Copy the value into all the rows

hic — Fri, 09 Sep 2022 07:10:47 GMT

Load ID,
Number as Number1
From <Source>
Where Len(Number)=6;

Join
Load ID,
Number as Number2
From <Source>
Where Len(Number)>6;

vikasshana — Fri, 09 Sep 2022 08:34:55 GMT

Thanks @hic it is working now.