Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
joaopassos97
Contributor II
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
PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂