What are the transformation can we do in Qlikview?

[#1]

Please give a list of transformation which we can do in Qlikview?

     1. Derived column Transformation (Like Invoice_date as Key_Date),

     2. Filter Transformation (through where keyword),

     3. Crosstable Transformation

     4. Join Transformation (Left join, right join etc)

     5. Merge Transformation (Concatenate)

     6. Sort Transformation (order by)

     7. Aggregation Transformation

     .......?

     .......?

     .......?

Regards,

Kabilan K.

[alexandros17]

I should add to your list crosstable transformation and all join operations ...

[#3]

Yes, Added.

Any more?

Can we say the crosstable transformation as Pivot transformation?

I think in SSIS we Pivot Transformation, so both are same?

Regards,

Kabilan K.

[#4]

Case Transform[using upper and lower,capitalize functions],

value trim ,

left function  ex:  for color field you have Blue as color   you need B only then use  left(color,1) it will give B].,

[swuehl]

- GROUP BY clause with aggregations

- looping in your input table records with WHILE

- doing MAPPINGs

- performing calculations based on input records

etc. etc.

Maybe just reference the reference manual.

[#6]

Hi Swuwhl,

Just I am checking, Whether we can do the all transformation like SSIS, Informatica or etc

That s Y UI am creating a list.

@john: Case transformation, string function, number function and Date function comes under Derived Column transformation.

[#7]

Yes I agree Kabilan  just for transformation point of you i said ,if it is useful for you go through it if not leave it.