Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
I have a strange problem. I am creating a dashboard for some survey.
Now the survey has Question & SubQuestion.
So for example
Question SubQuestion
1 1
1 2
1 10
1 11
I wish to represent the Question Number as 1.1, 1.2, 1.3, 1.10 format but when I concatenate Question & Sub Question it interprets it as numbers and shows both "1.1" & "1.10" as 1.1. Using Text or any function is of no user. Can anyone suggest what should I do?
Thanks in advance.
Amar
Good Day,
On you load use a combine function.
Example:
Question & '-' & SubQuestion as TotalQuestion
Thank You
This?
Load *,
Text(Question&'.'&SubQuestion) as New
Thanks for the reply Jan,
I know that changing the separator will solve the issue.
When displaying the data values I wish to show them as Index and thus want to use "." & not "_".
Any other suggestions?
you already have the answer to your question
load text(Question&'.'&SubQuestion) as Combined inline [
Question,SubQuestion
1,1
1,2
1,10
1,11
];
Try below as suggested by Tresesco.
You need to convert your SubQuestion to text in the script level then you could resolve this
LOAD * ,
Text(SubQuestion) as New_SubQuestion
from
then combine the two fields ..this will solve your problem
Hi Michael,
I don't notice this issue
LOAD *,Question&'.'&SubQuestion as A Inline [
Question SubQuestion
1 1
1 2
1 10
1 11
](delimiter IS SPACES);
However try
Question&'.'&Text(SubQuestion) as Field
Regards,
Antonio
Thanks a lot Tresesco. Will try this one
this should work
text(Question&'.'&SubQuestion) as QuestionNew