Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joaopassos97
New Contributor II

Search a parameter in a text file

Hi,

I have extracted a file from my system's configuration and I want to organize the configuration parameters in tabs.


The main problem is: The file is organized from up to down, wich means that everything is going to be in a single tab "@1".

I need to search the whole file to get the parameters I want. Here's an example:

MODULE TAG="LIC-206A_1" PLANT_AREA="AREA_A/CALDEIRAS" CATEGORY=""

user="ADMINISTRATOR" time=1164283218/* "23-Nov-2006 09:00:18" */

{

  DESCRIPTION="Master PID control loop"

  PERIOD=5

  CONTROLLER=""

  PRIMARY_CONTROL_DISPLAY=""

  INSTRUMENT_AREA_DISPLAY="LOOP_FP"

  DETAIL_DISPLAY="LOOP_DT"

  TYPE="Analog Control"

  SUB_TYPE="CASCADE_MASTER"

  ASSIGN_BLOCKS_TO_H1_CARD=F

  FUNCTION_BLOCK NAME="AI1" DEFINITION="FFAI"

  {

  DESCRIPTION="Analog Input"

  ID=100376530

  RECTANGLE= { X=40 Y=180 H=56 W=140 }

}
}

This above is a sample of an amount of 4k+ "tags".

What I want to do is : The red ones turn into the title of the sheet and the green ones are going to be the items of the table.
like this:

Ex.jpg

Is the Qlik Sense able to do what I need it for?

If "yes", how can I do it?

1 Reply

Re: Search a parameter in a text file

AFAIK it is not possible. might be possible using advance programming language like python

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Community Browser