topic Re: How to append strings in QlikView

How to append strings

Sat, 21 Sep 2013 12:37:21 GMT

Guys,

I am very new to QlikView.

I want to append strings in a for loop.

I am iterating a column in a table like this

Table:

LOAD *;

SQL SELECT t.column_name from column t

where t.table_id = $(tableid);

FOR j = 0 to (NoOfRows('Table'-1)

// at this point i need to concatenate column names along with some extra strings.

// pseudo code

// string = string + 'func1(column_name)'; // How to do this QlikView

Can anyone please tell me how to do it in QlikView?

I was trying Concat() like Concat(column_name,',') to see if it can at least to concatenation of column names but QlikView shows syntax error.

My real need is to do this // string = string + 'func1(column_name)';

Saurabh

Guys,

I have provided a sample data.

The output I need is two set of strings.

I need to iterate this one column in excel sheet and generate two strings.

1. Invoice, Bill, SalesOrder, Sales Receipt

2. Func1(Invoice, $(pwd)) as Func1Invoice, Func1(Bill, $(pwd)) as Func1Bill, Func1(SalesOrder, $(pwd)) as Func1SalesOrder, Func1(Sales Receipt, $(pwd)) as Func1Sales Receipt

Here 'pwd' is an other string whose value will be used here.

I hope this can help you guys to help me.

Re: How to append strings

tresB — Sun, 22 Sep 2013 08:44:30 GMT

'String1' & 'String2' & ExpressionYouWant // '&' is concatenation operator.

Re: How to append strings

Anonymous — Sun, 22 Sep 2013 10:37:31 GMT

Ramya

Try

let vstring = '$(vstring)' & 'MoreText' ;

Best Regards, Bill

Re: How to append strings

qlikpahadi07 — Sun, 22 Sep 2013 11:32:02 GMT

little confused can you give us a Demo like or attachment with output,

generally if you want to concatenate two columns Simple write

Column1 & Column2

Ramya Saurabh output will be "RamyaSaurabh"

Column1 &'-'& Column2 will give you "Ramya-Saurabh"

also

Date

22/Sep/2013

Month(Date) & ' - ' & Year(Date) will give Sep - 2013

Might be helpful

Re: How to append strings

Sun, 22 Sep 2013 19:13:11 GMT

Welcome to Qlikview. Please provide an example of what you want to achieve, e.g. sample input and desired output. This will make it easier for us to answer your question.

If you need each value in a certain column to have a fixed string appended, you could simply try:

LOAD

Column1 & 'Column1' AS Column1,

Column2 & 'Column2' AS Column2;

SQL LOAD ...

etc.

Re: How to append strings

Mon, 23 Sep 2013 05:49:30 GMT

Hi Ramya,

You can use '&' . It is the concatenation operator in qlikview.

For eg.

'Book' & ' ' & 'Mark' as Col1 will result in Book Mark

'Hello' & 'Test' as Col2 will result in HelloTest

I think in your case

String & 'Your expression' as String1

should work.

Hope this helps!

It will be easier to provide exact solution if you post a sample app with small data.

Re: How to append strings

CELAMBARASAN — Mon, 23 Sep 2013 08:42:18 GMT

Hi,

Concat is to concat the fieldvalues within in one field like to combine morethan one rows.

It can be used in Group by in Script and you can directly use in Presentation in text objects or in charts.

To append strings use & operator between two strings.

Example: ColumnName & 'String' & ColumnName1

Hope it helps

Re: How to append strings

Mon, 23 Sep 2013 13:49:24 GMT

Thanks Bill!

it works.

Thanks to every one who spent some time to help me. it was all helpful and I learnt from each one of them