I have fields like customer segment, Products, shipped date, Order Date, Product Id, Sales, Profit

[KommulaRahul]

I need to split these fields into two tables at back end side(load editor). 

I need to see these two tables in data model viewer

What is the script I need to add in back end 

[BrunPierre]

Hi, @KommulaRahul Can you share more information about what you are trying to do?

[KommulaRahul]

Ok i will send u the pic of the sample dataset . 

These fields need to be split into two tables. 

For that what I need to add in the load editor? 

 

[BrunPierre]

Is it what you looking for?

QUALIFY *;
T1:
LOAD CustomerSegment,
     Trim(SubField(Product,'-',1)) as Product,
     OrderDate,
     ShippedDate,
     Sales,
     Profit,
     ProductID
Resident MainTable;

T2:
LOAD CustomerSegment,
     Trim(SubField(Product,'-',2)) as Product,
     OrderDate,
     ShippedDate,
     Sales,
     Profit,
     ProductID
Resident MainTable;

DROP Table MainTable;

[KommulaRahul]

Thanks for the response

But i want few fields like customer segment, product, product ID, shipped date, order date in one table 

And sales ,profit in  one table. 

Dimensions in one table

Measures in one table 

Also is there any possibility to link these two tables

[BrunPierre]

I should have asked from the very start why the split and then associate them afterwards. Perhaps, you could post the output you expect.

[KommulaRahul]

Sorry @BrunPierre 

I forgot to mention about my requirement completely at the starting

The output what I'm expecting is 

Among those fields 

Few are dimensions and two are measures

So I want dimensions (CustomerSegment, Product, Product ID, Shipped Date, OrderDate) in one table and measures (Sales, Profit) in one table . 

Did u understand the requirement? 

[BrunPierre · Accepted solution]

To link these tables, perhaps something like this.

NoConcatenate
Dimensions:
LOAD ProductID,
CustomerSegment,
Product,
OrderDate,
ShippedDate
Resident MainTable;

Measures:
LOAD ProductID,
Sales,
Profit
Resident MainTable;

DROP Table MainTable;