# Data Driven Test Automation - New dummy object to fetch data from excel, IF-Else statement trigger span button click

**URL:** <https://forum.katalon.com/t/data-driven-test-automation-new-dummy-object-to-fetch-data-from-excel-if-else-statement-trigger-span-button-click/135160>\
**Category:** Web Testing\
**Tags:** if-else, dummy-object\
**Created:** [June 19, 2024, 9:23am UTC](https://forum.katalon.com/t/data-driven-test-automation-new-dummy-object-to-fetch-data-from-excel-if-else-statement-trigger-span-button-click/135160 "2024-06-19T09:23:31Z")\
**Posts on this page:** 1\
**Showing post:** 12

<div class="post-metadata">

**Author:** ![emlearn](https://dub1.discourse-cdn.com/katalon/user_avatar/forum.katalon.com/emlearn/32/23870_2.png) [@emlearn](https://forum.katalon.com/u/emlearn)\
**Post date:** [June 24, 2024, 5:16am UTC](https://forum.katalon.com/t/data-driven-test-automation-new-dummy-object-to-fetch-data-from-excel-if-else-statement-trigger-span-button-click/135160/12 "2024-06-24T05:16:42Z")

</div>

Hi @grylion54, thank you for the advice and tips. I will explore the parametrization later. In the meantime am thankful that your ealier solution has helped to fix the issue. Am actually beginner level.

[If else and variable - Product Forums / Katalon Studio - Katalon Community](http://forum.katalon.com/t/if-else-and-variable/61477)

Here’s my revised script that is working fine now. The respective buttons are clicked when condition is met.

```auto
	// Fetching price value from eTravel_TestData.xlsx, fulfil condition, respective button will be clicked
	
	if (findTestData('eTravel_TestData').getValue(3, rowNum) == "100") {
		
		WebUI.waitForElementClickable(findTestObject('DataDrivenTest eTravel/Page_Company/span_100.00'),
			5)

		WebUI.click(findTestObject('Object Repository/DataDrivenTest eTravel/Page_Company/span_100.00'))
	} else if (findTestData('eTravel_TestData').getValue(3, rowNum) == "200") {
		
		WebUI.waitForElementClickable(findTestObject('DataDrivenTest eTravel/Page_Company/span_200.00'),
			5)

		WebUI.click(findTestObject('Object Repository/DataDrivenTest eTravel/Page_Company/span_200.00'))
	} else if (findTestData('eTravel_TestData').getValue(3, rowNum) == "300") {
		
		WebUI.waitForElementClickable(findTestObject('DataDrivenTest eTravel/Page_Company/span_300.00'),
			5)

		WebUI.click(findTestObject('Object Repository/DataDrivenTest eTravel/Page_Company/span_300.00'))
	}

```

Thank you so very much 🙏 🙃

---

_[View the full topic](https://forum.katalon.com/t/data-driven-test-automation-new-dummy-object-to-fetch-data-from-excel-if-else-statement-trigger-span-button-click/135160)._