question

kamesh avatar image
kamesh asked ericnute edited

nested table and table mapper

HI

I am trying to develop a table mapper to parse a HTML table. The table i am working on should have broken into seperate tables, but to make my work challenging the table is just rows of info.

 

The table should be

 

IGMP property 1

IGMP property 2

IGMP interface1 name

IGMP interface1 prop 1

IGMP interface1 prop 2

IGMP interface1 group

IGMP interface1 group1 prop 1

IGMP interface1 group1 prop 2

IGMP interface2 name

IGMP interface2 prop 1

IGMP interface2 prop 2

IGMP stat1

IGMP stat2

 

 

(Please see the file attached for the real table output)

 

Using the table mapper and playing around with the table markers (Start & end) I am able to break the info multiple tables. But i have few issues where i can take some help/suggestions

 

1. How can i make a column value in a table header a key?

       In the above example "IGMP interface1 name"(Row 3) i would like to use the name as a key to fetch the values from interface table

 

2. How can i include the value in a table header part of my token

       When i declare a row as a table header the value stored in the column is no more tied to a token

 

3. How can i combine multiple keys to create a query to get values from the table?

       In the above example i would like to query something like table1->name1->option1

 

Please see the attached table map file for what i am really trying to solve

 

Thanks

 

 

iTestresponse maptable map
multicast_info.ffrm (38.3 KiB)
10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sreenath avatar image
sreenath answered sreenath posted

I have created the mixed mapping for the response. The query list shows queries generated for both table mapping and patterm mapping. 

 

Attached is the modified response map.

 

Hope it helps.


multicast_info.ffrm (56.2 KiB)
3 comments
10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kamesh avatar image kamesh commented ·

Thank Sreenath. I see more queries in this table mapper now.

But it hasn't provided what i was looking for. I would like to call group0 table with an interface name and group1 table with another interface. Would it be possible to generate it?

0 Likes 0 ·
sreenath avatar image sreenath kamesh commented ·

I would probably like to go back to your initial post.

 

1. How can i make a column value in a table header a key? In the above example "IGMP interface1 name"(Row 3) i would like to use the name as a key to fetch the values from interface table

 

--->In Table mapping we cannot make any value as key, column can only be declared as key. But I believe we can achieve this by making pattern matching where each value can act as token and we can declare the required token as key.

 

2. How can i include the value in a table header part of my token When i declare a row as a table header the value stored in the column is no more tied to a token

 

---> Table mapping will not add the header in the token list. But if we can start the next table from the last second row then the required row can appear in the token.

 

3. How can i combine multiple keys to create a query to get values from the table? In the above example i would like to query something like table1->name1->option1

 

---> Suppose you have four columns generated from table mapping in which column1 and column2 is set as key in this case,

 

column1_by_column2

column1_by_column3

column1_by_column4

 

column2_by_column1

column2_by_column3

column2_by_column4

 

I am not sure whether you are expecting for the same set of queries. Hope this information helps you!!

0 Likes 0 ·
kamesh avatar image kamesh sreenath commented ·

Thank you Sreenath

 

I think i need to compose what i want to do better. What i have in hand is a complex one and now i believe a response map is not going to solve it completely. I have some ideas now on developing a quick call that uses these responce maps to get the what i wanted.

 

Thanks

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.