Is it possible to Concat two field within intervalmatch() function..?

[sgg_gaikwad]

IntervalMatch:

IntervalMatch(Date)

LOAD

[GL Account Start]  &  [GL Account End]  Resident Layout;

OUtput: I want only two field in IntervalMatch table....

[#2]

hi

try according to this

IntervalMatch:

IntervalMatch(Date)

LOAD

[GL Account Start]  ,  [GL Account End]  Resident Layout;

[sgg_gaikwad]

Hi Vishwaranjan,

                     I did the same thing but i want only TWO field in INTervalMatch table....?

[#4]

hi

try this example

Key:

LOAD * INLINE [

Persons in Household/IncomeStart/IncomeEnd/IntervalName

1/24000/30000/<30%

1/30001/40000/31-40%

1/40001/50000/41-50%

2/25000/31000/<30%

2/31001/41000/31-40%

2/41001/51000/41-50%

] (delimiter is '/');

Population:

LOAD * INLINE [

Persons in Household/IncomeLevel

1/24020

2/45000

1/45500

4/35000

] (delimiter is '/');

IntervalMatch (IncomeLevel,[Persons in Household]) LOAD IncomeStart, IncomeEnd, [Persons in Household] Resident Key;

[hic]

You cannot do it in one pass. However, if you let the IntervalMatch prefix generate a temporary table, from which you in a second step create what you want, then it is doable. I do exactly this when I solve problems around Slowly changing dimensions.

See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions

IntervalMatch and Slowly Changing Dimensions

HIC

[er_mohit]

See the attached file for interval match