Inline Query

[Anonymous]

Hi Team,

I have the Inline table like the one below.

inline [
From,To,Match

230,235,10100
236,239,10101
];

Instead of giving the values 230,235,10100 etc.. is there a way I can import the data from sources.

If you could you please share the syntax.

Thanks & Regards

Jeba

[its_anandrjs]

As i understand by our base table that is Table2 then in place of the inline use QVD and please elaorate more about that we are so much near to the solution

Table2:

LOAD

[Zip Codes],

Match,

Left([Zip Codes],3) as ZipCode

From Table2.qvd(qvd);

NewTable:

LOAD

Match,

MinString(ZipCode) as [Zip Code_From],

MaxString(ZipCode) as [Zip Code_To]

Resident Table2

Group By Match;

Let me know about this.

[Anonymous]

Hi Anand

Thanks for the help.

I tried the logic,it seems some where I am missing the logic.

I am attaching the qvw file and the data I have used.

Note:Base tab will not have "Match" field.That is the one I am trying to map.

Could you please help me.

Thanks & Regards

Jeba

[Anonymous]

Hi Anand,

Did you had a chance to look at my message.

Could you please help me.

Thanks & Regards

Jeba

[Anonymous]

Hi Anand,

Did you had a chance to look at my message.

Could you please help me.

Thanks & Regards

Jeba