how to create a new filed value depending on other filed values

[dseelam]

Help,

I have field order type  a,b,c,d,e & field AccNum 1,2,3,4,5, in my QVW where a=1, b=2&5, c=3, d=4 & e=5&2 & it has many other columns related to account numbers

but now I want to create a new order type f where it should also be equal to 3 &4

I failed using if statement and match statement

when i use them I can create new order type f equals 3& 4 but I cant filter other columns

how to accomplish this ?

Message was edited by: Dinesh Reddy Seelam

[boorgura]

can you please share a sample QVW and/or sample data set?

[vinieme12]

Try This!

LOAD * INLINE [

OrderType,Accno

a,1

b,2

c,3

d,4

e,5

];

Load * INLINE [

OrderGroup, OrderType

f,c

f,d

];

[dseelam]

Rakesh,

I added the sample data set and source all I want to do is include ECOM in to datamodel with customer numbers mentioned

[boorgura]

you want to replace the current Order Type with ECOM?? or add an additional column - say Order Type 2?

[dseelam]

Rakesh,

I want to add new order type Ecom through customer numbers

if you see capture attachment I just added customer_number 1547 has ordertype ECOM but at the same time I want other data like Item descriptiom Item number  etc...

[dseelam]

Vineeth,

Thanks for the reply but I am talking about totally different thing hear

[boorgura]

In the main file - Cust 1547 has an Order Type as "US STandard Sales Order" - you want that to be changed to ECOM?

[dseelam]

For all the customers num provided in the source com I want customer type to be ecom instead of what ever they are before

[boorgura · Accepted solution]

Please find the updated logic